How to: Store calculated values in a database table in Access.
Solution:
A table stores all of the components of a calculation or expression. Since a calculated value is the result of an operation performed on data in the table, it is not necessary to store the value. To obtain and display calculated values, use expressions in queries, forms, or reports.